package com.ruoyi.system.mapper;

import com.ruoyi.system.domain.Evaluation;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

@Repository
public interface EvaluationMapper {
    //月查询
    Evaluation SelectOne01(Evaluation evaluation);

    //新增记录表
    void inssert(Evaluation evaluation);

    // 根据用户id以及时间修改记录表
    @Update("UPDATE evaluation SET quality_dimension=#{qualityDimension},ability_dimension=#{abilityDimension},total_score=#{totalScore},evaluation_date=#{evaluationDate} WHERE user_id=#{userId} AND evaluation_date=#{evaluationDate}")
    void update(Evaluation evaluation);

    //季度查询
    Map SelectOne02(Evaluation evaluation);


    List<Map<String,Object>> SelectByids(Map<String,Object> map);
}
